yilv_new/AA/Report/sql/[UFSystem]错误日志查询.sql

-- 功能权限
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Base WHERE cAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001' )
BEGIN
UPDATE UA_Auth_Base SET cAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001',cSub_Id=N'SA',iGrade=N'2',cSupAuth_Id=N'SARPT',bEndGrade=N'0',iOrder=N'77',cAuthType=NULL WHERE cAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Base(cAuth_Id,cSub_Id,iGrade,cSupAuth_Id,bEndGrade,iOrder,cAuthType)VALUES(N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001',N'SA',N'2',N'SARPT',N'0',N'77',NULL)
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'en-US',cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001',cAuth_Name=N'错误日志查询' WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'en-US',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001',N'错误日志查询')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-CN',cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001',cAuth_Name=N'错误日志查询' WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-CN',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001',N'错误日志查询')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-TW',cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001',cAuth_Name=N'错误日志查询' WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-TW',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001',N'错误日志查询')
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Base WHERE cAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_01' )
BEGIN
UPDATE UA_Auth_Base SET cAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_01',cSub_Id=N'SA',iGrade=N'3',cSupAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001',bEndGrade=N'1',iOrder=N'77',cAuthType=NULL WHERE cAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_01' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Base(cAuth_Id,cSub_Id,iGrade,cSupAuth_Id,bEndGrade,iOrder,cAuthType)VALUES(N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_01',N'SA',N'3',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001',N'1',N'77',NULL)
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_01' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'en-US',cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_01',cAuth_Name=N'Query:错误日志查询' WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_01' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'en-US',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_01',N'Query:错误日志查询')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_01' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-CN',cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_01',cAuth_Name=N'查询:''错误日志查询' WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_01' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-CN',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_01',N'查询:''错误日志查询')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_01' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-TW',cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_01',cAuth_Name=N'查詢:错误日志查询' WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_01' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-TW',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_01',N'查詢:错误日志查询')
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Base WHERE cAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_02' )
BEGIN
UPDATE UA_Auth_Base SET cAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_02',cSub_Id=N'SA',iGrade=N'3',cSupAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001',bEndGrade=N'1',iOrder=N'77',cAuthType=NULL WHERE cAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_02' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Base(cAuth_Id,cSub_Id,iGrade,cSupAuth_Id,bEndGrade,iOrder,cAuthType)VALUES(N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_02',N'SA',N'3',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001',N'1',N'77',NULL)
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_02' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'en-US',cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_02',cAuth_Name=N'Configurat错误日志查询' WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_02' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'en-US',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_02',N'Configurat错误日志查询')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_02' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-CN',cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_02',cAuth_Name=N'设置:''错误日志查询' WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_02' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-CN',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_02',N'设置:''错误日志查询')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_02' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-TW',cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_02',cAuth_Name=N'設置:错误日志查询' WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_02' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-TW',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_02',N'設置:错误日志查询')
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Base WHERE cAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_03' )
BEGIN
UPDATE UA_Auth_Base SET cAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_03',cSub_Id=N'SA',iGrade=N'3',cSupAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001',bEndGrade=N'1',iOrder=N'77',cAuthType=NULL WHERE cAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_03' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Base(cAuth_Id,cSub_Id,iGrade,cSupAuth_Id,bEndGrade,iOrder,cAuthType)VALUES(N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_03',N'SA',N'3',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001',N'1',N'77',NULL)
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_03' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'en-US',cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_03',cAuth_Name=N'Print:错误日志查询' WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_03' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'en-US',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_03',N'Print:错误日志查询')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_03' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-CN',cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_03',cAuth_Name=N'打印:''错误日志查询' WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_03' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-CN',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_03',N'打印:''错误日志查询')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_03' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-TW',cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_03',cAuth_Name=N'列印:错误日志查询' WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_03' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-TW',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_03',N'列印:错误日志查询')
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Base WHERE cAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_04' )
BEGIN
UPDATE UA_Auth_Base SET cAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_04',cSub_Id=N'SA',iGrade=N'3',cSupAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001',bEndGrade=N'1',iOrder=N'77',cAuthType=NULL WHERE cAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_04' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Base(cAuth_Id,cSub_Id,iGrade,cSupAuth_Id,bEndGrade,iOrder,cAuthType)VALUES(N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_04',N'SA',N'3',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001',N'1',N'77',NULL)
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_04' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'en-US',cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_04',cAuth_Name=N'Output:错误日志查询' WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_04' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'en-US',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_04',N'Output:错误日志查询')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_04' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-CN',cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_04',cAuth_Name=N'输出:''错误日志查询' WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_04' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-CN',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_04',N'输出:''错误日志查询')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_04' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-TW',cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_04',cAuth_Name=N'輸出:错误日志查询' WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_04' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-TW',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_04',N'輸出:错误日志查询')
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Base WHERE cAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_05' )
BEGIN
UPDATE UA_Auth_Base SET cAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_05',cSub_Id=N'SA',iGrade=N'3',cSupAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001',bEndGrade=N'1',iOrder=N'77',cAuthType=NULL WHERE cAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_05' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Base(cAuth_Id,cSub_Id,iGrade,cSupAuth_Id,bEndGrade,iOrder,cAuthType)VALUES(N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_05',N'SA',N'3',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001',N'1',N'77',NULL)
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_05' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'en-US',cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_05',cAuth_Name=N'Publish:错误日志查询' WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_05' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'en-US',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_05',N'Publish:错误日志查询')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_05' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-CN',cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_05',cAuth_Name=N'发布:''错误日志查询' WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_05' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-CN',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_05',N'发布:''错误日志查询')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_05' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-TW',cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_05',cAuth_Name=N'發佈:错误日志查询' WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_05' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-TW',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_05',N'發佈:错误日志查询')
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Base WHERE cAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_fcb05799-1092-4653-b7e5-271e59d452a2' )
BEGIN
UPDATE UA_Auth_Base SET cAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_fcb05799-1092-4653-b7e5-271e59d452a2',cSub_Id=N'SA',iGrade=N'3',cSupAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001',bEndGrade=N'1',iOrder=N'77',cAuthType=NULL WHERE cAuth_Id=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_fcb05799-1092-4653-b7e5-271e59d452a2' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Base(cAuth_Id,cSub_Id,iGrade,cSupAuth_Id,bEndGrade,iOrder,cAuthType)VALUES(N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_fcb05799-1092-4653-b7e5-271e59d452a2',N'SA',N'3',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001',N'1',N'77',NULL)
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_fcb05799-1092-4653-b7e5-271e59d452a2' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'en-US',cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_fcb05799-1092-4653-b7e5-271e59d452a2',cAuth_Name=N'View:错误日志查询' WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_fcb05799-1092-4653-b7e5-271e59d452a2' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'en-US',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_fcb05799-1092-4653-b7e5-271e59d452a2',N'View:错误日志查询')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_fcb05799-1092-4653-b7e5-271e59d452a2' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-CN',cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_fcb05799-1092-4653-b7e5-271e59d452a2',cAuth_Name=N'视图:错误日志查询' WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_fcb05799-1092-4653-b7e5-271e59d452a2' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-CN',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_fcb05799-1092-4653-b7e5-271e59d452a2',N'视图:错误日志查询')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_fcb05799-1092-4653-b7e5-271e59d452a2' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-TW',cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_fcb05799-1092-4653-b7e5-271e59d452a2',cAuth_Name=N'視圖:错误日志查询' WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_fcb05799-1092-4653-b7e5-271e59d452a2' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-TW',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_fcb05799-1092-4653-b7e5-271e59d452a2',N'視圖:错误日志查询')
END
GO


-- 门户菜单相关
DELETE FROM UfSystem..UA_Menu WHERE cMenu_Id=N'SARPT213639' 
INSERT INTO UfSystem..UA_Menu(cMenu_Id,cMenu_Name,cMenu_Eng,cSub_Id,IGrade,cSupMenu_Id,bEndGrade,cAuth_Id,iImgIndex,Paramters,Depends,Flag)VALUES(N'SARPT213639',N'错误日志查询',N'4',N'SA',N'1',N'SA',N'1',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001_01',N'0',NULL,NULL,NULL)
GO

DELETE FROM UfSystem..UFMenu_Business_Lang WHERE MenuId=N'SARPT213639' AND LocaleId=N'en-US' 
INSERT INTO UfSystem..UFMenu_Business_Lang(MenuId,Caption,LocaleId)VALUES(N'SARPT213639',N'错误日志查询',N'en-US')
DELETE FROM UfSystem..UFMenu_Business_Lang WHERE MenuId=N'SARPT213639' AND LocaleId=N'zh-CN' 
INSERT INTO UfSystem..UFMenu_Business_Lang(MenuId,Caption,LocaleId)VALUES(N'SARPT213639',N'错误日志查询',N'zh-CN')
DELETE FROM UfSystem..UFMenu_Business_Lang WHERE MenuId=N'SARPT213639' AND LocaleId=N'zh-TW' 
INSERT INTO UfSystem..UFMenu_Business_Lang(MenuId,Caption,LocaleId)VALUES(N'SARPT213639',N'错误日志查询',N'zh-TW')
GO

DELETE FROM UfSystem..ua_idt WHERE id=N'SARPT213639' 
INSERT INTO UfSystem..ua_idt(id,assembly,catalogtype,type,class,entrypoint,parameter,reserved)VALUES(N'SARPT213639',N'.\UAP\UFIDA.U8.UAP.Services.ReportManagement.dll',N'0',N'2',N'UFIDA.U8.UAP.Services.ReportManagement.OpenReportServer4PortalMenu',NULL,NULL,NULL)
GO